SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347943 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347943 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416746,733668,111669,53125,64227,115426,1021086,34821,856929,308627,648672,102482,354867,1042749,967715,640274,194867,168955,168193,678378,357207,64740,697326,227273,380964,535164,1022212,728122,371908,195637,724715,86297,536598,778619,997645,229075,979651,55221,125237,982533,57354,981327,357267,713045,10434,867095,754863,148574,351000,291694,798975,579685,471161,673889,250504,446055,524284,31805,642972,28751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]