SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105016 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105016 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901040,168396,132724,264864,803279,612957,603374,366717,42897,728210,129420,434199,408394,244893,577016,391454,600546,474536,125599,425059,629602,756364,935524,902138,884432,948727,697861,1016615,616026,407473,690839,575895,641827,234062,73225,715053,275233,351069,734104,350647,634790,345092,914964,489020,712690,571129,868959,445779,399483,123766,575998,818082,476030,47638,128378,919660,954379,261892,854734,795072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]