SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022040 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022040 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822132,168312,314074,194756,177701,848618,917476,117041,524394,1023484,140283,886922,958975,493778,863391,183872,88384,161960,920189,520747,499356,560153,460880,1043034,978632,185315,69596,659221,662317,253696,62409,615479,76930,84852,996347,828145,1043936,632688,184727,862957,887278,814042,589293,944076,487190,183328,191811,915787,647922,742073,977557,123242,913394,837312,922946,301777,280854,22425,981953,470429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]