SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191980 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191980 [ RunTime:0.003405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455774,800184,692849,948261,693881,10816,375691,203191,850600,331659,463235,875268,166411,615279,519480,601071,1033811,964673,724683,133972,41997,321864,789586,228810,234977,834292,223183,23875,497986,683426,363818,952366,91543,881419,701382,767867,872737,1033769,443356,526547,284616,659410,449041,65741,148019,456519,165618,173543,756723,271518,46393,647389,458689,595125,152337,49181,912670,770572,718385,623626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]