SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506889 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506889 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829101,711277,206270,69669,73297,551680,569855,87506,363150,8473,762946,1033510,185462,337,560657,399244,372427,776293,445668,243183,654888,433259,713919,893853,87028,687375,808705,648649,385361,742752,855570,551470,219738,333805,870475,436916,601787,685228,279893,75224,959120,351805,785491,877924,237488,513881,469830,1011260,679839,123792,1026619,5081,428170,463622,662427,825834,740890,663057,401197,716928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]