SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113314 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113314 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723003,779719,114611,1042907,39318,64168,541362,798746,1042471,949736,164770,371607,545141,487645,471938,148211,821805,1566,573532,476638,499874,85868,388980,763212,739606,12966,390743,486817,75978,162812,809830,1039357,567964,59914,234574,407673,378880,702081,39437,189507,442232,57608,485277,309615,861350,750155,474127,376970,486300,383127,382531,416952,836738,452320,780225,1026272,938595,836005,198205,338207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]