SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 992418 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 992418 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28255,1812,363043,204200,717734,1040331,673879,825878,720606,498595,361675,341416,180806,512286,763148,452968,562405,462662,681178,1043938,786249,589664,419263,387600,109061,396903,775633,970113,375921,312882,690174,649258,521847,490434,879777,572540,259372,611123,1000342,122853,881157,1003995,540654,720135,633661,783159,229765,988735,455373,834698,328484,646127,848490,574841,150025,357351,837197,71477,875996,1030859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 992418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 992418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002592s ]