SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513812 LIMIT 1 [ RunTime:0.004502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513812 [ RunTime:0.003744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310035,939444,621180,596474,177972,1018847,871837,536602,344561,683341,692921,766614,584686,561846,1026329,715830,131325,726675,360535,171079,353168,557833,110754,107156,1003095,665715,788238,807123,550334,672078,1038867,354238,996642,376756,687703,123187,20154,986670,569035,897953,233719,405100,540889,981591,330219,236685,451360,674177,506225,116505,204586,764335,178133,431761,600790,2323,182788,446102,339233,876541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]