SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509910 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509910 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046159,388843,384424,134980,1980,699572,65666,963639,115562,196405,711605,673303,551387,566899,851761,845944,216881,507514,818146,654142,98511,15195,69722,921289,258789,972885,155782,672680,746856,783445,971474,363754,976545,102182,758330,611077,375461,644560,264014,950388,565170,86126,598281,210163,13952,751547,284780,249972,717365,477015,839034,1048561,998788,971779,858717,18363,88783,110174,519235,793604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]