SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444946 LIMIT 1 [ RunTime:0.000712s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444946 [ RunTime:0.002173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938145,258156,442395,692910,883053,464916,33070,1037648,236479,985040,915017,488151,641324,112645,979395,139534,525944,410893,390884,867653,1038472,778905,749860,177796,25675,434353,298797,671159,850319,803777,32667,484953,8366,356482,168127,96980,626428,759548,1024220,830080,942349,936503,523073,745258,522941,829028,358220,263551,264830,1001153,937789,639482,768075,1044307,835050,776635,94173,452361,574119,510524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]