SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508794 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508794 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524164,356630,974088,230350,71848,1048869,889191,305907,6649,264900,6435,900103,129614,1026314,664981,382145,1020848,340235,611331,770981,648383,1030778,1021210,271824,528742,903711,233706,890837,70314,992967,450257,876265,946291,500078,17763,264708,566263,792307,469016,833309,496088,835737,389257,251720,2629,673312,538850,83240,615889,863924,564232,629799,363517,920824,864798,876612,760911,541592,419787,193488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]