SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016068 LIMIT 1 [ RunTime:0.000747s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016068 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529934,1004059,971156,884551,175126,865976,602,94322,532607,941636,798678,1039107,806965,787283,614422,236931,909845,691109,275565,336587,12789,296305,326943,521291,644811,100274,330860,829889,676102,681448,699284,162011,132075,1030509,489564,949777,466151,1020586,200271,915246,63325,39595,1038263,319758,834052,950062,61855,78084,706709,800382,778621,357601,904900,777151,1018171,187903,991589,151058,986079,966115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002055s ]