SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487254 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487254 [ RunTime:0.002023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951248,109705,190798,821536,631332,969155,600596,174660,957294,93886,360929,787302,353057,1010046,457132,257596,279733,601083,59987,1030111,371478,629138,424210,921917,242807,152449,63973,185083,720985,322728,4259,60925,391459,58286,718039,448948,901797,591983,668253,162393,927957,814988,778642,776499,506663,788321,894188,452736,825556,530335,44316,773761,1030832,84118,559711,493583,751011,657942,462906,58789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]