SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523983 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523983 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54807,941819,205559,567234,42274,600498,932320,333248,701620,495840,864372,92702,330380,661577,843461,1046886,532207,200868,805101,33729,102668,537183,389764,662588,65767,304767,332271,28435,664867,421502,349769,832819,720950,135782,985879,377867,1018622,999797,1032101,760902,551904,44893,367776,4317,89267,185117,652862,525913,399719,338542,140661,197657,207199,341912,920513,41850,617037,715300,363010,902079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]