SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416432 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416432 [ RunTime:0.002657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007291,724682,208099,852720,753074,500660,90068,174014,148576,11054,220664,1011023,1019993,1044967,462467,204261,181110,202426,79604,460835,664063,1031501,965165,329011,201109,184467,198346,884238,205696,547946,862456,505901,875370,499885,272214,668213,68232,501588,568581,761198,736810,322135,935176,634143,541648,689536,309840,147260,570897,6555,748181,749085,538947,734155,429635,575229,242826,577884,728822,331804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]