SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141096 LIMIT 1 [ RunTime:0.001012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141096 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467085,136192,875220,239844,72154,837143,920562,734926,843942,755383,184217,795099,301986,49628,676442,600983,874470,525241,66362,809744,1021712,876382,361506,410666,387986,315898,433428,417783,134591,379922,314216,1029751,539178,408884,350275,882615,729717,932784,596411,881748,566458,849838,1005125,472858,192423,370741,696806,632432,93826,265246,175553,712581,430657,294222,305347,440115,853088,504216,276032,15438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]