SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478613 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478613 [ RunTime:0.003611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882097,826668,511126,68080,667379,112198,944410,590006,365515,198703,283476,300571,309133,817279,868296,686311,825709,600792,991866,847920,521434,910081,843155,402870,541793,1038882,311895,50415,680063,93630,696203,638727,56164,575602,185887,720367,804861,923181,740358,212647,802513,495977,672087,356828,309647,126960,354784,854865,748157,791196,512163,488707,535749,516266,272640,967538,624322,235516,735049,24504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]