SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 182019 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 182019 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501352,715198,106190,26161,353143,504680,988567,962357,736967,422028,890556,1046582,648824,724998,260357,653561,915067,588850,490670,902784,646586,353589,164357,585768,375207,367856,56262,301163,449855,270578,522397,774741,619761,312025,697460,663523,713546,146549,769747,277952,842090,56936,1011036,798030,37970,231706,575410,203929,276912,443488,387202,364387,617470,131336,894412,220453,221461,439623,334461,889879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 182019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 182019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002132s ]