SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329643 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329643 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697841,1028650,811842,758049,476845,719526,368880,309380,405890,865059,773976,731697,122481,824262,959165,493618,38790,1008148,986799,1013899,183448,539633,458024,397925,25090,694614,350321,1020825,522409,991787,299979,818618,883991,304373,403445,715647,396860,964529,1027942,316350,535610,548211,517083,337655,768933,758608,853191,807040,343891,220068,819109,222292,632556,456465,301809,841291,991604,1009792,590732,321969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]