SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687517 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687517 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595067,80280,1041355,434205,496221,111837,811099,733391,444704,304249,640481,373488,258399,332006,846177,581808,115961,518073,48101,764458,754404,944230,736125,941351,464357,1024313,407635,566862,488050,136749,700034,713742,416958,125071,802660,215441,792140,339174,666795,972641,971211,858089,897000,94845,314830,547055,983173,652504,596661,477508,839799,531705,699293,960333,907054,124276,986561,954440,790989,866333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]