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` = 2894 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2894 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117215,46621,802599,920343,149450,995328,680940,389393,452182,867137,441129,8050,17890,285931,707056,76725,862584,76139,468603,416654,995971,765323,605445,43574,123487,716258,1003591,427673,400850,471718,312902,261378,807787,799294,596042,152113,1018695,759621,66863,929929,281353,910910,5252,341684,329327,623080,745854,238924,677887,888784,970371,648568,31431,134524,622696,180627,715814,428393,643514,175658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]