SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473938 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473938 [ RunTime:0.003471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403370,296210,767232,242294,10690,91542,26757,1006304,598905,210903,550750,164693,426164,861276,1021222,97873,903984,422193,824151,605414,103100,464326,481114,118102,145477,583298,89944,539582,398202,245706,949652,715840,1002146,162256,419122,368440,758796,585782,1028738,514285,550382,636044,345191,4249,738044,618383,926578,845984,414411,848520,846661,886357,1004034,550164,310644,498721,288759,1025808,57322,477202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]