SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567932 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567932 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774678,625320,1026410,792885,11419,188334,68036,970524,625106,1012600,372843,423455,664840,386868,685827,37204,801247,883908,582328,596781,208459,1040422,678067,686269,1045430,817319,39405,945803,983226,981175,164272,178718,97936,1015089,813123,995399,194504,32549,471082,407231,191692,630988,157325,373026,73044,664311,319579,1027192,440309,697810,162872,510517,352936,840937,1019823,838931,287872,757427,954077,58505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567932 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567932 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001117s ]