SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488038 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488038 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158099,658761,943871,183996,891891,670851,758150,1045846,358872,950514,224936,127365,969642,243229,230923,37192,122619,824456,29873,946830,805024,11710,1006073,190634,174568,213916,964192,338850,28349,998620,517262,992824,223063,43834,721268,952126,711975,448989,994149,530178,244880,1023490,486319,281023,601243,492916,362541,102599,593848,1014089,396740,476272,962401,110446,1003753,981242,992371,285233,490378,386980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]