SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4031 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4031 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484930,916433,688422,983188,103960,724478,641739,155159,223344,843553,179619,752437,663326,576071,505654,1028223,22796,900058,817356,382464,875555,479923,735286,586413,890878,528768,774624,532348,850262,340383,466587,774913,291319,693552,115916,894962,367707,213271,479117,851056,589026,100549,335842,92532,907713,240256,130444,659641,501794,147122,1045902,305706,803139,821354,176941,243440,83582,557662,936122,401561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]