SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 944813 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 944813 [ RunTime:0.001260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419555,98046,1038873,202266,868017,850209,663354,314821,763328,863964,86130,698324,640910,870639,99974,1041486,506724,254331,266235,338916,299514,339917,392103,203193,783654,956012,696291,415727,691939,405017,636410,849778,849626,990475,961799,179982,587016,258223,853683,565194,797287,317522,13092,475401,253478,574152,544946,998416,218759,1007516,358355,85032,498384,379848,870686,421534,806920,262391,589983,861972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 944813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 944813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004294s ]