SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 74571 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 74571 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439182,554375,429795,346797,666246,289849,110902,257056,160180,1019745,759320,534056,96091,263442,887469,25289,386272,19093,114452,756732,674586,442478,408257,754600,980732,863867,961481,268624,938723,233101,966099,323304,48989,298214,845721,87004,886593,699388,271454,357519,682102,317075,628398,346029,967329,278231,395468,258046,910852,666857,131093,592261,532250,346394,744,557334,174586,1010587,134193,911040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 74571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 74571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]