SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535909 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535909 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295114,304038,982531,648673,921672,505631,247548,975610,594275,139256,161910,106617,857404,283774,569018,650932,245183,984138,547250,480684,832681,250472,274230,406230,480100,960756,256254,577227,224601,553670,306476,897870,555865,136881,98727,1009415,407785,678560,823052,754278,315634,107206,498808,507676,19688,37719,113211,1016133,308477,192273,976639,237763,621894,86000,762031,56766,733905,16040,803335,317643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]