SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022811 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022811 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546086,375153,245998,109920,456748,988662,949202,916393,689334,416604,45621,724371,607990,120753,308401,785365,829867,901236,44924,620644,457525,375772,28328,109277,23917,195566,741553,715957,278987,251547,202015,455413,390238,50379,1040031,741123,403619,579604,743183,373108,982524,433714,311701,940476,130391,656109,6102,324675,159246,154286,1034495,627041,691594,452915,564129,813460,151605,430164,773597,224612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]