SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421156 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421156 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376585,1008396,123793,874579,376520,566160,114383,947914,416664,544082,6920,237949,761928,448079,101764,510937,885457,1000649,940354,633729,884615,792582,195515,760972,580528,447273,646420,538283,564702,175901,1008156,967711,156520,434112,181427,762331,162909,269592,177067,834934,503535,72007,797657,886510,886881,658911,860630,421202,270212,331646,899653,81542,787743,539280,574499,105079,402220,234199,36734,382104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]