SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484318 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484318 [ RunTime:0.001361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10849,652218,567567,703406,312085,635409,627908,891574,868880,244959,928578,949768,38661,386322,878595,407550,895917,1000943,745702,333053,319304,719970,850738,603200,434982,526894,548067,721496,342591,773733,395473,678132,617677,138910,802193,318602,659660,374458,883954,124176,934207,547150,810153,578811,516900,173544,623748,514390,473948,1014511,477188,393004,128326,606323,725656,853674,578263,619428,11133,930995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000963s ]