SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425106 LIMIT 1 [ RunTime:0.001233s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425106 [ RunTime:0.003626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53063,892190,1043899,311804,263295,720361,990604,863713,291430,510470,122363,795097,7200,111989,541807,555704,908865,668102,698594,1631,824716,936162,48736,839243,814333,434042,126235,300201,357724,531061,849694,417470,964189,633474,531838,363201,362639,197104,293216,422392,651086,800231,215398,132404,383611,921299,537564,45753,636482,910303,337745,13168,593451,522340,756924,83843,20466,849002,429476,292345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000942s ]