SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036319 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036319 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192418,72833,193521,314264,1033733,497143,233353,554346,213267,92333,436944,329861,541851,270887,279557,185601,215280,921057,542080,813860,158188,535481,491095,640556,977101,741772,1002276,187729,247339,978545,858677,375067,596322,306574,992641,386982,377479,863441,449605,240285,203507,709091,693465,389326,325667,320300,718013,374371,1014099,612393,948723,948390,198520,115276,882820,220658,940278,891239,130861,749151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]