SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580180 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580180 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469363,584663,102958,483786,707633,295074,122329,1007984,845440,256587,243135,97556,62203,827843,182540,681312,444073,419936,198429,990906,356425,358515,796506,846846,834435,862034,330290,614769,180563,545276,219242,102119,131977,541804,1039943,560489,152424,393302,759142,1043513,572671,471413,567864,596827,162752,421995,1024764,649333,649659,689417,102012,367594,589742,799758,806333,23037,52004,91753,147972,264295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005852s ]