SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512010 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512010 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975488,887877,561108,536590,564874,642783,934373,279620,604991,695637,741629,359687,809781,286848,233021,88524,424022,320076,927570,939767,173231,864211,759011,698321,392450,54922,310880,960203,673760,351385,906237,642579,408752,519093,800985,242249,434815,454743,1002646,592235,420565,503381,381491,925594,774755,1030587,554899,408281,119564,163412,786595,196875,797462,396155,664080,932341,829355,646998,239226,816506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]