SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501761 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501761 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576283,359806,1031116,593334,550334,168940,749510,473227,315328,494566,373089,664134,128191,748271,665943,198710,1015484,542501,104094,637296,436530,673511,382400,26664,960471,576331,1015682,117851,939987,157972,907319,740460,281245,792472,736840,312560,905256,101869,141605,78534,575424,719176,972360,368271,194482,846600,498083,605647,361431,939112,49075,659120,1035457,732719,447353,703541,74309,833133,108780,455164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]