SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972558 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972558 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364914,383615,351373,837815,201645,256558,411230,20114,517166,879974,524037,661482,976740,1048550,1028071,583670,579289,643058,369873,831471,185404,1047113,893859,965117,838846,423497,486070,647730,784683,624295,720102,967318,361071,239527,947781,6378,806971,578169,1009980,285039,600090,432992,641382,157287,332268,761020,425614,46984,276846,312544,217188,96292,682213,730502,325318,127750,241715,661145,526051,182621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]