SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101419 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101419 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593293,403646,338508,207550,411424,923323,798169,575178,1009737,64124,412127,590150,465688,223670,818506,683799,642329,185626,497721,564054,481391,657431,500524,270590,729367,612940,210793,848650,333140,591199,392649,516292,532961,544179,253045,546195,521572,129624,101647,831607,193562,687852,686675,643513,1003413,698879,241399,853859,472003,962754,56806,317639,683914,142457,919798,774047,593797,957388,615182,645419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]