SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039388 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039388 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321981,540555,850974,637107,1010837,966377,848107,565193,755023,95644,383258,542722,265652,178377,810076,785584,832275,1033926,430132,1024879,938710,13342,125099,268364,498114,258072,667254,68297,218803,472465,566498,837280,544854,922136,649199,577302,497207,813920,555061,412300,186251,126093,320139,1033238,304082,517335,406185,301272,51519,534998,701725,833164,207252,721339,261770,539321,972568,985816,854952,1036908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]