SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000728 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000728 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124429,749992,591514,513699,742239,1028689,743579,777085,804777,238280,536489,853836,416899,111260,257026,190852,113408,493325,678745,258403,857513,420143,568716,189748,473745,968253,888397,431359,640388,450620,127541,531276,912114,244641,383930,14484,752489,120992,365230,793086,311960,831257,104490,698197,630660,237465,886128,805112,516455,1006407,63057,499520,374553,228071,39394,117562,403383,947951,1042184,495907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]