SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525698 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525698 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180994,905785,988468,834475,140628,261065,258335,763451,203192,826207,955522,603861,255353,521857,221975,485430,29872,371479,735765,729761,426898,1036032,369090,975663,1007588,320720,983392,646924,180675,751641,840029,1252,478269,89690,286895,768303,745742,23963,1047789,858187,267478,851578,526733,274258,263655,668211,963001,53888,30200,679956,482822,308019,150454,758286,276318,229862,858775,718953,590620,483736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]