SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504966 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504966 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313512,505915,392132,404866,459228,479527,916295,28123,256603,491143,867177,133408,629560,1048680,1002947,13652,816541,780843,387363,840984,514306,608413,186342,344358,381419,819867,869904,58780,885116,805146,451469,1035317,528370,696576,575770,391622,330808,569802,679683,449646,227121,49671,78896,241541,729101,81276,877474,514386,166485,754941,896276,461396,916843,407506,888588,599091,733955,72126,1026099,399035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]