SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429483 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429483 [ RunTime:0.001437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362969,709030,925859,354257,148008,497275,217418,815607,481490,691920,288289,688781,166778,959381,271239,619305,891151,585610,124862,634442,139236,1016550,797155,562402,544302,918989,813380,464013,98775,649041,162627,49833,1034086,838162,921596,102105,932322,969393,265362,301276,279839,590177,916920,267286,575973,911974,912013,825814,69250,153178,379449,443213,523275,411842,691051,799583,219739,859247,866980,215059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]