SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473860 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473860 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297600,483414,1020340,355220,769006,461021,997544,939711,222972,310812,994240,193630,453969,220618,768360,1048824,348129,473467,245314,758698,805412,288198,263281,1018045,146650,1030393,622048,825160,840838,1010759,614109,734535,335271,972155,545783,792766,249545,70911,1041839,442412,272568,736333,244990,467220,60377,583025,274537,179722,329847,982089,936036,467049,392942,497191,288731,89556,61509,927508,1029238,806440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]