SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549221 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549221 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614595,262705,882499,298546,45868,200856,445300,495460,743310,520342,40163,687514,1026425,379634,799471,501308,438399,233210,269930,406235,873085,243028,958196,346063,500123,659790,118195,502210,614601,161284,790165,185324,731811,643020,1008358,692741,286118,108617,768358,302107,572097,544369,222248,623364,1001281,771052,421439,118983,1015762,664846,21139,283208,404054,924531,670605,680236,372224,569251,915666,672822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]