SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034587 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034587 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684457,351719,990696,478783,191736,693791,512044,893202,380281,513168,804033,881579,931971,733134,882181,158271,481818,506165,678667,565600,672778,926858,829666,658389,894152,429093,86848,127712,972494,340949,861033,1034819,808300,874916,66412,687159,352243,832306,965767,348699,559969,226726,312641,170981,767081,835863,770067,35839,228257,325072,833117,36954,393376,302063,257074,985866,677965,601046,296851,920965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034587 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034587 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001353s ]