SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003824s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 78651 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 78651 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567541,385765,522038,586554,34465,617655,11603,500856,1045041,778209,769357,978369,276688,551572,434695,414981,47680,290003,259067,70808,87583,320936,437243,55837,439690,220035,130387,816610,205332,915651,192648,1028160,424947,882399,171968,258417,578000,180232,409588,901162,748337,132502,87761,287167,43652,791661,971814,561073,389791,734010,1042131,558537,572011,874650,255619,386501,7775,181663,951380,291759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 78651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 78651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001508s ]