SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009366 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009366 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147300,843888,919073,938405,414335,198115,678147,1044410,787156,459213,55139,847013,908508,853368,203166,705643,1000605,499697,52233,966961,789925,104634,1031269,176945,817447,1021576,504906,804778,249503,111458,510794,124259,1033260,318081,577888,726241,302182,331362,901408,49710,192418,930803,5236,774393,116077,166767,53820,422604,75836,282076,20158,326625,290489,302640,17170,985505,744042,685233,214573,64909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]