SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030404 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030404 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537411,84558,542860,674322,380685,497989,836192,424738,363536,990294,59304,244162,271205,717102,943240,998535,766995,772519,652510,848997,257952,57070,17195,55206,651588,462046,277582,744126,917868,153899,531926,573417,956867,1034757,620914,628630,20224,596717,41391,442945,736221,883846,683759,9099,45378,937151,240521,1045885,810213,177435,791863,199255,889143,752645,599300,576149,6503,757644,37911,276412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]