SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504056 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504056 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23768,1025157,601933,396883,989113,121841,169238,857156,733110,992578,31470,324169,60935,82865,469203,989414,175069,275792,168666,69834,903766,303227,295341,437612,624384,38539,117962,978047,457648,525846,222271,644704,403818,847199,183988,408549,398876,655215,562025,339922,221952,109571,339721,693316,706862,90380,666296,629615,215015,146685,284662,526096,597147,479723,634216,20671,852784,42666,107826,1038823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]