SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814940 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814940 [ RunTime:0.003751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109797,1021489,244920,429118,395966,116544,181552,484392,1015883,1046898,655356,736360,456250,437508,631767,745974,969784,842008,1008887,131508,379989,257888,169769,111510,949291,91304,83151,952754,670343,139649,76633,996147,588734,226795,1023756,29123,807064,958430,480318,301818,269,664987,290238,973979,365609,949858,947294,740809,707385,442318,720417,16226,1034825,612845,569103,257295,697085,69433,21913,811443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000990s ]