SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034543 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034543 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762023,288285,50370,774277,899215,282492,29262,29618,530613,88092,371834,525414,810550,396689,4929,73682,580396,975457,111248,612060,238540,668320,817066,1008499,991891,78139,396184,672597,382838,394509,835,385252,922195,951526,729349,690472,793749,257306,70119,653467,803288,739210,308348,147760,170474,311051,333742,987294,312456,124093,706177,750171,444778,645530,405934,459680,703371,305322,347235,697065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]