SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484838 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484838 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142059,671604,759287,564150,421858,21361,64757,135377,1033919,202003,289245,470360,50643,240018,601993,883914,758677,984866,584324,1007837,792222,945277,40438,214988,856129,100460,1016958,1003681,16930,610665,84124,865445,961742,239668,731361,937006,772879,845183,54405,625666,412849,471664,883320,842063,307245,557657,447695,835136,649964,996996,1006361,321246,107865,18865,736472,606204,714913,586566,740214,278860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]