SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513787 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513787 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014651,838656,749262,261076,492400,283533,290281,274518,70899,245943,400818,330610,34482,704293,721132,148496,736377,435223,989922,675307,180153,770901,601514,126275,584141,101184,291554,502273,743598,339873,78082,870912,53718,834840,284398,262013,87196,452395,189499,148691,660677,382532,379626,596092,179301,485838,860629,590378,579573,259627,1042714,890890,831581,484179,624432,932381,928160,309579,679145,564347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]