SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268321 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268321 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68304,981001,527989,714612,17403,1044438,862367,466665,310889,77739,477912,670812,113781,665436,193350,12435,943189,743480,524843,441489,52446,517836,709644,789602,177185,549527,710015,1011175,67879,434095,1003888,726865,972762,614263,162970,1041221,594598,260817,663897,772661,6142,412594,629379,403550,885873,274307,973338,969142,921486,555779,110893,920856,1025716,474690,421193,256561,17995,81552,883782,224066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]