SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53115 LIMIT 1 [ RunTime:0.000804s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53115 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210537,438374,810502,650113,119197,905496,142521,316819,408743,62190,658808,385303,841518,440399,292645,822774,184632,346279,894515,530711,40813,501227,561409,217844,743316,841983,277671,739407,642698,88449,575094,1023728,453576,752189,630478,220805,282731,619594,1047253,578106,698432,226226,497441,934674,1040742,353425,987497,538993,87674,572528,351934,793744,497419,447717,926883,666505,529567,551998,575782,110254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]