SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532901 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532901 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512011,554797,480696,366358,536523,847584,688958,1012105,95753,1019075,272988,833216,551010,198608,935135,277370,979469,238109,900633,641766,358308,611663,930701,965519,987162,624812,721139,239796,36532,83824,135081,499096,564587,509478,149258,400557,834780,388025,334021,395119,558078,991434,253010,243412,519014,421229,902342,115642,242716,591980,217551,798878,41883,427337,307171,677879,50054,781699,834768,555129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]