SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391953 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391953 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403829,997884,758832,774032,846779,878267,860598,13299,55813,1046467,935308,900187,545082,24966,988797,455296,202419,568164,538180,1008323,465834,8241,195263,775063,809073,218319,298229,159313,1010961,325195,469381,641151,958573,504285,794263,157833,638439,1037553,713336,422375,695107,399642,775572,772339,961988,345079,876147,831823,784860,408984,906992,610094,386811,351443,633228,34418,644033,56775,361107,409989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]