SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343813 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343813 [ RunTime:0.003048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692443,221926,1022567,134717,465246,826788,495484,527986,147585,857250,873743,395907,840870,162654,234748,519516,266215,51547,789011,431077,876630,308165,708023,357369,432909,94438,729546,912388,774854,474676,107262,494018,588644,549149,232225,818111,597809,553942,555351,338592,813239,38300,569966,1046477,109427,562156,705802,1042537,852166,975681,663385,791399,568217,964894,379927,834626,119028,868154,580825,679943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001062s ]