SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457103 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457103 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700181,398523,622552,345441,988970,974971,455673,214503,529574,1007786,54989,898801,102114,713550,1046268,394213,767896,553298,762109,269790,309256,593274,312962,814199,316201,389321,660724,608032,319554,86100,992135,1033475,47450,931660,282385,601385,14483,985786,303732,508514,151975,618658,70102,650039,800252,979803,328205,957457,389380,883833,219591,706238,855737,217316,485157,80020,714894,934332,470009,422924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]