SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56010 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56010 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114817,1001273,565008,413240,733449,239166,596483,222867,965743,329460,450769,821523,947754,58539,750079,200740,691410,392651,601624,324863,616288,997606,246611,110278,769476,232478,570494,281328,831549,933288,968624,133433,833130,1034244,808905,347429,604903,366065,17301,897286,1005766,801031,192412,625959,557846,664290,550786,823067,402032,300305,462979,355545,648873,926919,551239,342253,208260,315227,229474,771033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]