SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525005 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525005 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285607,1039714,806110,798052,47384,412614,484344,104153,742992,431773,801052,186274,597717,611166,32695,599058,490968,31330,383514,67895,877204,114457,43617,649196,285592,283759,348577,869011,575602,522033,33352,721,445440,234198,685440,89906,890435,882820,44113,514771,1034798,600329,376622,254354,617898,826165,284419,747026,1036217,38681,820814,1032133,215176,321007,354092,583453,1027603,280544,140599,296170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]