SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412851 LIMIT 1 [ RunTime:0.001490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412851 [ RunTime:0.003247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549550,248506,911179,20112,403611,13739,487270,713679,326941,986409,221066,66708,464365,59465,551356,320710,474803,590904,605436,124242,655290,362437,135575,304221,183444,565865,500599,210804,110007,1014727,197357,915805,197452,253362,564930,911543,1030122,938140,726646,973533,1007553,1275,136384,44760,483686,484615,89410,340391,343713,889276,891969,1026711,747094,940494,58860,10825,907687,327425,15569,315918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001195s ]