SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510432 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510432 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029757,809435,294237,25502,355692,331077,486917,339082,608452,82530,153378,337880,981082,749437,971939,155318,715555,1042521,596230,1017985,381166,128207,305985,834040,483949,1044770,298769,224490,412210,199709,743922,421111,815787,25581,656310,28464,289956,651464,972660,139481,433898,975621,45825,275750,727490,729631,488677,965003,1017923,546919,775578,747297,100429,1004617,989689,1015633,606028,835435,813328,183452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]