SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283693 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283693 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11801,412263,214925,432933,1032032,102509,430608,927577,371656,18211,582420,37658,543632,52277,382609,318398,703747,513857,327523,449384,101604,505807,997027,403308,413802,196368,464796,187067,570259,228570,529542,1018849,415908,24543,363267,115897,588457,497186,7676,770974,395991,521155,527775,38562,530416,133539,393269,250489,796960,172978,63572,518088,325032,323656,236800,451335,1008342,698453,1033475,38580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]