SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492851 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492851 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747555,976384,821081,39946,1009426,474058,660586,691514,834863,165055,656645,645173,218367,621150,728801,173390,757450,1015567,796631,632255,876742,334328,876321,321475,577888,148457,516394,740253,417432,937638,355148,254218,120180,403031,138819,661987,497239,558436,732028,947156,1005234,473458,321300,177493,123023,908092,885075,160183,608571,587542,171032,34876,930326,808828,877427,577852,260835,666569,104427,177854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]